SET IDENTITY_INSERT [dbo].[store] ON;

Select * from store where store_id = 300;
if @@ROWCOUNT =0
BEGIN
INSERT INTO store ( Store_ID, Description, CompanyName, TradingAs, Address, ContactNo, VATRegNo, 
RegNo, StoreEmailAddress
) VALUES ('300', 'Cash Crusaders Hebron Mall','Cash Crusades Stores (Pty)Ltd','Cash Crusaders Hebron Mall','Shop no 81, Hebron Road, Hebron, West of Soshanguve','TBA','4270290184','2012/030200/07','masubelelep@gmail.com');
 END
ELSE
 BEGIN
UPDATE Store set Description = 'Cash Crusaders Hebron Mall',CompanyName = 'Cash Crusades Stores (Pty)Ltd', TradingAs = 'Cash Crusaders Hebron Mall', Address='Shop no 81, Hebron Road, Hebron, West of Soshanguve', ContactNo = 'TBA', VATRegNo = '4270290184',RegNo = '2012/030200/07', StoreEmailAddress = 'masubelelep@gmail.com' where Store_ID = 300;
 END


 SET IDENTITY_INSERT [dbo].[store] off